<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
 //读取数据
require_once "../data.php";

 $sql="select * from student";

 $result =mssql_query($sql,$sqlcon);
 echo "<table border=1 width=40% align=center>
 <tr> <td>id</td> <td>name</td> <td>sex</td> </tr>";
 while($row=mssql_fetch_array($result))
 {
	echo "<tr>";
	echo "<td>".convert2utf8($row["id"])."</td>";
	echo "<td>".convert2utf8($row["name"])."</td>";
	echo "<td>".convert2utf8($row["sex"])."</td>";
	echo "</tr>";
 }
 echo "</table>";
?>

<hr>

<form action="insert.php" method="post">
name(char 10): <input type="text" name="name" />
sex(bit):  <input type="text" name="sex"  />
<input type="submit" value="插入" />
</form>

<hr>

<form action="update.php" method="post">
id(int): <input type="text" name="id" />
name(char 10): <input type="text" name="name" />
sex(bit):  <input type="text" name="sex"  />
<input type="submit" value="更新"/>
</form>

<hr>

<form action="delete.php" method="post">
id(int): <input type="text" name="id" />
<input type="submit" value="删除" />
</form>

